package com.xiaow.android.ebook.app.database;

public class DBConstant {
	public static final String DB_NAME = "novel_ebook";
	public static final String CHAPTER = "chapter";
	public static final String NOVEL = "novel";
	public static final String MENU_PAGE = "menuPage";
	public static final String NOVELSTATION = "NovelStation";
	public static final String[] SQLS = {
			"CREATE TABLE chapter (is_pic integer DEFAULT 0,chapter_path text,"
					+ "chapter_url text,chapter_name text,novelname text,id integer PRIMARY KEY AUTOINCREMENT)",
			"CREATE TABLE novel ( novel_cover text ,novel_menu_url text,novel_path text ,"
					+ "	novel_url text ,author text ,novel_name text ,id integer PRIMARY KEY  AUTOINCREMENT",
			"CREATE TABLE menuPage( chapter_end text ,chapter_start text,fascicute_end text,"
					+ "fascicule_start text ,menu_end text,menu_start text ,name text ,novel_menu_url text,"
					+ "novel_url text,id integer PRIMARY KEY  AUTOINCREMENT",
			"CREATE TABLE NovelStation(chapert_updatetime_reg text ,page_reg text"
					+ ",isNameDIV text ,novelAuthorReg text ,novelTypeReg text"
					+ ",list_result_reg text ,menu_url text ,searchURL text ,name_url_reg"
					+ "text ,Name text ,isdown text ,id integer PRIMARY KEY  AUTOINCREMENT" };

	public static final class chapter {
		public static final String ID = "id";
		public static final String CHAPTER_PATH = "chapter_path";
		public static final String CHAPTER_URL = "chapter_url";
		public static final String CHAPTER_NAME = "chapter_name";
		public static final String NOVEL_NAME = "novelname";
		public static final String[] FROM = { ID, CHAPTER, CHAPTER_NAME,
				CHAPTER_PATH, CHAPTER_URL };
	}

	public static final class novel {
		public static final String id = "id";
		public static final String novel_name = "novel_name";
		public static final String author = "author";
		public static final String novel_url = "novel_url";
		public static final String novel_path = "novel_path";
		public static final String novel_menu_url = "novel_menu_url";
		public static final String novel_cover = "novel_menu_url";
		public static final String[] FROM = { id, novel_name, author,
				novel_url, novel_path, novel_menu_url, novel_cover };
	}

	public static final class MenuPage {
		public static final String id = "id";
		public static final String novel_url = "novel_url";
		public static final String novel_menu_url = "novel_menu_url";
		public static final String name = "name";
		public static final String menu_start = "menu_start";
		public static final String menu_end = "menu_end";
		public static final String fascicule_start = "fascicule_start";
		public static final String fascicule_end = "fascicule_end";
		public static final String chapter_start = "chapter_start";
		public static final String chapter_end = "chapter_end";
		public static final String[] FROM = { id, name, novel_menu_url,
				novel_url, menu_start, menu_end, fascicule_start,
				fascicule_end, chapter_start, chapter_end };
	}

	public static final class novelstation {
		public static final String chapert_updatetime_reg = "chapert_updatetime_reg";
		public static final String page_reg = "page_reg";
		public static final String isNameDIV = "isNameDIV";
		public static final String novelAuthorReg = "novelAuthorReg";
		public static final String novelTypeReg = "novelTypeReg";
		public static final String list_result_reg = "list_result_reg";
		public static final String menu_url = "menu_url";
		public static final String searchURL = "searchURL";
		public static final String name_url_reg = "name_url_reg";
		public static final String Name = "Name";
		public static final String isdown = "isdown";
		public static final String id = "id";

		public static final String[] FROM = { id, chapert_updatetime_reg,
				page_reg, isNameDIV, novelAuthorReg, novelTypeReg,
				list_result_reg, menu_url, name_url_reg, Name, isdown };
	}

}
